Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
MembershipProgramID (PK) | Token ID for a CustomerRewardProgram instance. | ID_CT_MBRSHP_PRGM | Identity | integer | |
CustomerRewardProgramTypeCode | A code used to indicate the class or category of customer reward related to this program. Valid values include: LOYALTY_PROGRAM CLUB_MEMBERSHIP_PROGRAM | CD_CT_RWD_PRGM_TYP | Code | varchar(20) | |
FeeChargedFlag | A boolean indicator that if YES means that a customer pays a fee to enroll in the CustomerRewardProgram. If NO, they do not pay a fee. Note that a customer always registers (i.e. in the ARTS model they must be a KeyCustomer and have an account relationship established.) | FL_FE_CHRGD | Flag | integer | |
FeeRenewalTypeCode | Designates the fee (if FeeChargedFlag is YES) renewal type. Valid values are: ONETIME RENEWABLE | CD_FE_RNWL_TYP | Code | varchar(20) | |
EnrollmentRenewalPeriodCode | Designates a renewal period type for this program if its FeeChargedFlag is YES and its FeeRenewalTypeCode is 'RENEWABLE'. Valid values are: CALENDAR_YEAR ANNUAL_ANNIVERSERY_DATE SEMIANNUAL QUARTERLY MONTHLY | CD_ENRLLMNT_RNWL_PRD | Code | varchar(20) | |
ProrateFeeFlag | A boolean indicator that if YES means that a calendar year (or other calendar based renewal period) fee will be prorated based on the actual program enrollment date. For example customer X joins Y wholesale club on July 1 and Y has a calendar year based membership program -- customer X will pay half the annual fee to enroll. There after, the customer will pay a full year fee to remain a member in good standing. | FL_PRRT_FE | Flag | integer | |
CustomerMembershipProgramFeeAmount | Monetary Value of the fee that is paid by a customer to enroll in the CustomerRewardProgram. | MO_FE | Money | decimal(16,5) | |
Name | Generic membership club name used primarily for internal reporting. Names used to advertise and promote a CustomerMembershipProgram are delegated to the subtype entities. | NM_PRGM_MBRSHP | Name | varchar(40) | |
Description | Text that describes a club membership program. | DE_PRGM_MBRSHP | DescriptionNarrative | varchar(4000) | |
EffectiveDate | The date that a loyalty program becomes available. | DC_PRGM_MBRSHP_EF | EffectiveDate | date | |
ExpirationDate | The date after which the loyalty program is no longer available. | DC_PRGM_MBRSHP_EX | ExpirationDate | date | |
RedemptionInstantDeferredTypeCode | A code that indicates if the redemption of points is instant (based on rules fired at the point of sale) or deferred which requires a separate action on the part of the customer and/or retailer. Valid Values: DEFERRED INSTANT INSTANT redemption of points may happen any time after they are earned. Typically they are redeemed automatically using electronic coupons. Deferred redemptions mean that points may be redeemed at a later time based on a retailer defined event or trigger. | CD_RDM_INSTNT_DFR_TYP | Code | varchar(20) | |
StatusCode | Indicates the status of this CustomerRewardProgram entity instance. Sample values include: A = Active I = Inactive | STS_CD | Code2Status | char(2) | |
MembershipProgramProcessorID (FK) | Token ID for a CustomerRewardProgramProcessor | ID_CT_MBRSHP_PRGM_PCSR | Identity | integer | CustomerMembershipProgramProcessor(PA_CT_MBRSHP_PRGM_PCSR) |
MembershipProgramSponsorID (FK) | Token ID for a CustomerRewardProgramSponsor | ID_MBRSHP_PRGM_SPNSR | Identity | integer | CustomerMembershipProgramSponsor(PA_CT_MBRSHP_PRGM_SPNSR) |
ProgramTypeCode (FK) | Designates a category of CustomerMembershipProgram. Sample values include: LOYALTY SUBSCRIPTION | CD_PRGM_TYP | Code | varchar(20) | CustomerMembershipProgramType(CO_CT_MBRSHP_PRGM_TYP) |